﻿CREATE TABLE [dbo].[DicAddress] (
    [AdsID]    INT           NOT NULL,
    [AdsPID]   INT           NULL,
    [AdsName]  NVARCHAR (50) NULL,
    [Alias]    VARCHAR (20)  NULL,
    [AdsLevel] TINYINT       NULL,
    [AdsName2] NVARCHAR (50) NULL,
    CONSTRAINT [PK_DicAddress] PRIMARY KEY CLUSTERED ([AdsID] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'地区城市库。地区城市表', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicAddress';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'父标识', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicAddress', @level2type = N'COLUMN', @level2name = N'AdsPID';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'名称', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicAddress', @level2type = N'COLUMN', @level2name = N'AdsName';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'别名', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicAddress', @level2type = N'COLUMN', @level2name = N'Alias';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'地区级别。10：大洲/大洋级；20：国家级；30：地区级；40:省级；50:市级；60：县级；70：乡/镇级；80：村级', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'DicAddress', @level2type = N'COLUMN', @level2name = N'AdsLevel';

